You can connect to Fineo through SqlLine - a standard console based SQL access tool.
How To
1. Download
The Fineo-specific build of sqlline is available here [1].
2. Prepare
Unpack the tarball and then copy in the desired fineo jdbc jar (see jdbc for the jar) to
lib/
. If you want logging you can also copy in you desired logging framework (Fineo leverages
Slf4j everywhere); we recommend using logback [2].
3. Start
Now you are ready to start the sqlline shell:
$ ./sqlline
4. Connect!
Start by entering the connection credentials:
sqlline> !connect jdbc:fineo:api_key=<your api key>
If you did not enter a authentication method (see JDBC guide), you can enter your IAM credentials as a username (access key) and password (secret key) combination:
Enter username for jdbc:fineo;api_key=<key>:
Enter password for jdbc:fineo:api_key=<key>:
That's it. From there you can easily access all of your data through SQL!
5. Examples
Here are some simple things you can do in Sqlline.
List tables
sqlline> !tables
Get all rows in a table
sqlline> SELECT * FROM <table name>
6. Exiting
Crtl-C (the usual exit option) only cancels the previous command. Instead you need to use:
sqlline> !quit
Notes
1. Sqlline
We include a couple of fixes, like loading the properties file correctly and using lib/ vs. changing the java-ext dir. For more details, see our fork.
2. Logback
For logback, the jars you need are: logback-core and logback-classic. Download these jars and add them to the lib/
directory.